/*
 * Copyright 2012 SURFnet bv, The Netherlands
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package org.surfnet.oaaas.repository;

import java.util.List;

import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import org.springframework.stereotype.Repository;
import org.surfnet.oaaas.model.ResourceServer;

@Repository
public interface ResourceServerRepository extends CrudRepository<ResourceServer, Long> {

  List<ResourceServer> findByOwner(String owner);

  ResourceServer findByIdAndOwner(Long id, String owner);

  ResourceServer findByKey(String key);
  /**
   * @author Mr Zhou
   * @param owner
   * @param isDelet
   * @return
   */
  List<ResourceServer> findByOwnerAndIsDelete(String owner,int isDelet);
 
  List<ResourceServer>  findByOwnerAndIsDeleteAndOpen(String owner,int isDelet,boolean open);
  @Query("select rs from ResourceServer rs where rs.isDelete = 0 and rs.owner=?1 and rs.pay = ?2  and rs.name like ?3")
  Page<ResourceServer> findByPayAndNameLike(String owner,boolean pay,String name,Pageable pageable);
  
  @Query("select rs from ResourceServer rs where rs.isDelete = 0 and rs.owner=?1")
  public Page<ResourceServer> findByOwnerPageable(String owner,Pageable pageable);
  @Query("select rs from ResourceServer rs where rs.isDelete = 0 and rs.owner=?1 and rs.open=?2 and rs.pay =?3")
  public Page<ResourceServer> findByOwnerAndOpenAndPayPageable(String owner,boolean open,boolean pay,Pageable pageable);
  
  @Query("select rs from ResourceServer rs where rs.isDelete = 0 and rs.owner=?1 and rs.pay =?2")
  public Page<ResourceServer> findByOwnerAndPayPageable(String owner,boolean pay,Pageable pageable);
}
